package com.gopay.remote.fundcps.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class FundpGopayFastpayCardsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public FundpGopayFastpayCardsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andKeyIdIsNull() {
            addCriterion("KEY_ID is null");
            return (Criteria) this;
        }

        public Criteria andKeyIdIsNotNull() {
            addCriterion("KEY_ID is not null");
            return (Criteria) this;
        }

        public Criteria andKeyIdEqualTo(Long value) {
            addCriterion("KEY_ID =", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdNotEqualTo(Long value) {
            addCriterion("KEY_ID <>", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdGreaterThan(Long value) {
            addCriterion("KEY_ID >", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdGreaterThanOrEqualTo(Long value) {
            addCriterion("KEY_ID >=", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdLessThan(Long value) {
            addCriterion("KEY_ID <", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdLessThanOrEqualTo(Long value) {
            addCriterion("KEY_ID <=", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdIn(List<Long> values) {
            addCriterion("KEY_ID in", values, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdNotIn(List<Long> values) {
            addCriterion("KEY_ID not in", values, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdBetween(Long value1, Long value2) {
            addCriterion("KEY_ID between", value1, value2, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdNotBetween(Long value1, Long value2) {
            addCriterion("KEY_ID not between", value1, value2, "keyId");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNull() {
            addCriterion("CUST_ID is null");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNotNull() {
            addCriterion("CUST_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCustIdEqualTo(String value) {
            addCriterion("CUST_ID =", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotEqualTo(String value) {
            addCriterion("CUST_ID <>", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdGreaterThan(String value) {
            addCriterion("CUST_ID >", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdGreaterThanOrEqualTo(String value) {
            addCriterion("CUST_ID >=", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLessThan(String value) {
            addCriterion("CUST_ID <", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLessThanOrEqualTo(String value) {
            addCriterion("CUST_ID <=", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLike(String value) {
            addCriterion("CUST_ID like", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotLike(String value) {
            addCriterion("CUST_ID not like", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdIn(List<String> values) {
            addCriterion("CUST_ID in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotIn(List<String> values) {
            addCriterion("CUST_ID not in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdBetween(String value1, String value2) {
            addCriterion("CUST_ID between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotBetween(String value1, String value2) {
            addCriterion("CUST_ID not between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNull() {
            addCriterion("MERCHANT_ID is null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNotNull() {
            addCriterion("MERCHANT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdEqualTo(String value) {
            addCriterion("MERCHANT_ID =", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotEqualTo(String value) {
            addCriterion("MERCHANT_ID <>", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThan(String value) {
            addCriterion("MERCHANT_ID >", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanOrEqualTo(String value) {
            addCriterion("MERCHANT_ID >=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThan(String value) {
            addCriterion("MERCHANT_ID <", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanOrEqualTo(String value) {
            addCriterion("MERCHANT_ID <=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLike(String value) {
            addCriterion("MERCHANT_ID like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotLike(String value) {
            addCriterion("MERCHANT_ID not like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIn(List<String> values) {
            addCriterion("MERCHANT_ID in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotIn(List<String> values) {
            addCriterion("MERCHANT_ID not in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdBetween(String value1, String value2) {
            addCriterion("MERCHANT_ID between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotBetween(String value1, String value2) {
            addCriterion("MERCHANT_ID not between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andBankCardNoIsNull() {
            addCriterion("BANK_CARD_NO is null");
            return (Criteria) this;
        }

        public Criteria andBankCardNoIsNotNull() {
            addCriterion("BANK_CARD_NO is not null");
            return (Criteria) this;
        }

        public Criteria andBankCardNoEqualTo(String value) {
            addCriterion("BANK_CARD_NO =", value, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoNotEqualTo(String value) {
            addCriterion("BANK_CARD_NO <>", value, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoGreaterThan(String value) {
            addCriterion("BANK_CARD_NO >", value, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_CARD_NO >=", value, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoLessThan(String value) {
            addCriterion("BANK_CARD_NO <", value, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoLessThanOrEqualTo(String value) {
            addCriterion("BANK_CARD_NO <=", value, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoLike(String value) {
            addCriterion("BANK_CARD_NO like", value, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoNotLike(String value) {
            addCriterion("BANK_CARD_NO not like", value, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoIn(List<String> values) {
            addCriterion("BANK_CARD_NO in", values, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoNotIn(List<String> values) {
            addCriterion("BANK_CARD_NO not in", values, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoBetween(String value1, String value2) {
            addCriterion("BANK_CARD_NO between", value1, value2, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andBankCardNoNotBetween(String value1, String value2) {
            addCriterion("BANK_CARD_NO not between", value1, value2, "bankCardNo");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignIsNull() {
            addCriterion("FUNDPAY_BIND_SIGN is null");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignIsNotNull() {
            addCriterion("FUNDPAY_BIND_SIGN is not null");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignEqualTo(String value) {
            addCriterion("FUNDPAY_BIND_SIGN =", value, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignNotEqualTo(String value) {
            addCriterion("FUNDPAY_BIND_SIGN <>", value, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignGreaterThan(String value) {
            addCriterion("FUNDPAY_BIND_SIGN >", value, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignGreaterThanOrEqualTo(String value) {
            addCriterion("FUNDPAY_BIND_SIGN >=", value, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignLessThan(String value) {
            addCriterion("FUNDPAY_BIND_SIGN <", value, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignLessThanOrEqualTo(String value) {
            addCriterion("FUNDPAY_BIND_SIGN <=", value, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignLike(String value) {
            addCriterion("FUNDPAY_BIND_SIGN like", value, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignNotLike(String value) {
            addCriterion("FUNDPAY_BIND_SIGN not like", value, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignIn(List<String> values) {
            addCriterion("FUNDPAY_BIND_SIGN in", values, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignNotIn(List<String> values) {
            addCriterion("FUNDPAY_BIND_SIGN not in", values, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignBetween(String value1, String value2) {
            addCriterion("FUNDPAY_BIND_SIGN between", value1, value2, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andFundpayBindSignNotBetween(String value1, String value2) {
            addCriterion("FUNDPAY_BIND_SIGN not between", value1, value2, "fundpayBindSign");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountIsNull() {
            addCriterion("MONEY_ACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountIsNotNull() {
            addCriterion("MONEY_ACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountEqualTo(Integer value) {
            addCriterion("MONEY_ACCOUNT =", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountNotEqualTo(Integer value) {
            addCriterion("MONEY_ACCOUNT <>", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountGreaterThan(Integer value) {
            addCriterion("MONEY_ACCOUNT >", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountGreaterThanOrEqualTo(Integer value) {
            addCriterion("MONEY_ACCOUNT >=", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountLessThan(Integer value) {
            addCriterion("MONEY_ACCOUNT <", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountLessThanOrEqualTo(Integer value) {
            addCriterion("MONEY_ACCOUNT <=", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountIn(List<Integer> values) {
            addCriterion("MONEY_ACCOUNT in", values, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountNotIn(List<Integer> values) {
            addCriterion("MONEY_ACCOUNT not in", values, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountBetween(Integer value1, Integer value2) {
            addCriterion("MONEY_ACCOUNT between", value1, value2, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountNotBetween(Integer value1, Integer value2) {
            addCriterion("MONEY_ACCOUNT not between", value1, value2, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoIsNull() {
            addCriterion("APP_SHEET_SERIAL_NO is null");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoIsNotNull() {
            addCriterion("APP_SHEET_SERIAL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoEqualTo(String value) {
            addCriterion("APP_SHEET_SERIAL_NO =", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoNotEqualTo(String value) {
            addCriterion("APP_SHEET_SERIAL_NO <>", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoGreaterThan(String value) {
            addCriterion("APP_SHEET_SERIAL_NO >", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoGreaterThanOrEqualTo(String value) {
            addCriterion("APP_SHEET_SERIAL_NO >=", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoLessThan(String value) {
            addCriterion("APP_SHEET_SERIAL_NO <", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoLessThanOrEqualTo(String value) {
            addCriterion("APP_SHEET_SERIAL_NO <=", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoLike(String value) {
            addCriterion("APP_SHEET_SERIAL_NO like", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoNotLike(String value) {
            addCriterion("APP_SHEET_SERIAL_NO not like", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoIn(List<String> values) {
            addCriterion("APP_SHEET_SERIAL_NO in", values, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoNotIn(List<String> values) {
            addCriterion("APP_SHEET_SERIAL_NO not in", values, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoBetween(String value1, String value2) {
            addCriterion("APP_SHEET_SERIAL_NO between", value1, value2, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoNotBetween(String value1, String value2) {
            addCriterion("APP_SHEET_SERIAL_NO not between", value1, value2, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoIsNull() {
            addCriterion("FUND_CUST_NO is null");
            return (Criteria) this;
        }

        public Criteria andFundCustNoIsNotNull() {
            addCriterion("FUND_CUST_NO is not null");
            return (Criteria) this;
        }

        public Criteria andFundCustNoEqualTo(Integer value) {
            addCriterion("FUND_CUST_NO =", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoNotEqualTo(Integer value) {
            addCriterion("FUND_CUST_NO <>", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoGreaterThan(Integer value) {
            addCriterion("FUND_CUST_NO >", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("FUND_CUST_NO >=", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoLessThan(Integer value) {
            addCriterion("FUND_CUST_NO <", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoLessThanOrEqualTo(Integer value) {
            addCriterion("FUND_CUST_NO <=", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoIn(List<Integer> values) {
            addCriterion("FUND_CUST_NO in", values, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoNotIn(List<Integer> values) {
            addCriterion("FUND_CUST_NO not in", values, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoBetween(Integer value1, Integer value2) {
            addCriterion("FUND_CUST_NO between", value1, value2, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoNotBetween(Integer value1, Integer value2) {
            addCriterion("FUND_CUST_NO not between", value1, value2, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdIsNull() {
            addCriterion("TRANSACTION_ACCOUNT_ID is null");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdIsNotNull() {
            addCriterion("TRANSACTION_ACCOUNT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdEqualTo(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID =", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdNotEqualTo(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID <>", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdGreaterThan(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID >", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID >=", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdLessThan(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID <", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID <=", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdLike(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID like", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdNotLike(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID not like", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdIn(List<String> values) {
            addCriterion("TRANSACTION_ACCOUNT_ID in", values, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdNotIn(List<String> values) {
            addCriterion("TRANSACTION_ACCOUNT_ID not in", values, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdBetween(String value1, String value2) {
            addCriterion("TRANSACTION_ACCOUNT_ID between", value1, value2, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdNotBetween(String value1, String value2) {
            addCriterion("TRANSACTION_ACCOUNT_ID not between", value1, value2, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andAcountTypeIsNull() {
            addCriterion("ACOUNT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andAcountTypeIsNotNull() {
            addCriterion("ACOUNT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andAcountTypeEqualTo(String value) {
            addCriterion("ACOUNT_TYPE =", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeNotEqualTo(String value) {
            addCriterion("ACOUNT_TYPE <>", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeGreaterThan(String value) {
            addCriterion("ACOUNT_TYPE >", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeGreaterThanOrEqualTo(String value) {
            addCriterion("ACOUNT_TYPE >=", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeLessThan(String value) {
            addCriterion("ACOUNT_TYPE <", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeLessThanOrEqualTo(String value) {
            addCriterion("ACOUNT_TYPE <=", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeLike(String value) {
            addCriterion("ACOUNT_TYPE like", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeNotLike(String value) {
            addCriterion("ACOUNT_TYPE not like", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeIn(List<String> values) {
            addCriterion("ACOUNT_TYPE in", values, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeNotIn(List<String> values) {
            addCriterion("ACOUNT_TYPE not in", values, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeBetween(String value1, String value2) {
            addCriterion("ACOUNT_TYPE between", value1, value2, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeNotBetween(String value1, String value2) {
            addCriterion("ACOUNT_TYPE not between", value1, value2, "acountType");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagIsNull() {
            addCriterion("AUTHENTICATE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagIsNotNull() {
            addCriterion("AUTHENTICATE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagEqualTo(String value) {
            addCriterion("AUTHENTICATE_FLAG =", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagNotEqualTo(String value) {
            addCriterion("AUTHENTICATE_FLAG <>", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagGreaterThan(String value) {
            addCriterion("AUTHENTICATE_FLAG >", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagGreaterThanOrEqualTo(String value) {
            addCriterion("AUTHENTICATE_FLAG >=", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagLessThan(String value) {
            addCriterion("AUTHENTICATE_FLAG <", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagLessThanOrEqualTo(String value) {
            addCriterion("AUTHENTICATE_FLAG <=", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagLike(String value) {
            addCriterion("AUTHENTICATE_FLAG like", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagNotLike(String value) {
            addCriterion("AUTHENTICATE_FLAG not like", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagIn(List<String> values) {
            addCriterion("AUTHENTICATE_FLAG in", values, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagNotIn(List<String> values) {
            addCriterion("AUTHENTICATE_FLAG not in", values, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagBetween(String value1, String value2) {
            addCriterion("AUTHENTICATE_FLAG between", value1, value2, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagNotBetween(String value1, String value2) {
            addCriterion("AUTHENTICATE_FLAG not between", value1, value2, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameIsNull() {
            addCriterion("BANK_BRANCH_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameIsNotNull() {
            addCriterion("BANK_BRANCH_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameEqualTo(String value) {
            addCriterion("BANK_BRANCH_NAME =", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameNotEqualTo(String value) {
            addCriterion("BANK_BRANCH_NAME <>", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameGreaterThan(String value) {
            addCriterion("BANK_BRANCH_NAME >", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_BRANCH_NAME >=", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameLessThan(String value) {
            addCriterion("BANK_BRANCH_NAME <", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameLessThanOrEqualTo(String value) {
            addCriterion("BANK_BRANCH_NAME <=", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameLike(String value) {
            addCriterion("BANK_BRANCH_NAME like", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameNotLike(String value) {
            addCriterion("BANK_BRANCH_NAME not like", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameIn(List<String> values) {
            addCriterion("BANK_BRANCH_NAME in", values, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameNotIn(List<String> values) {
            addCriterion("BANK_BRANCH_NAME not in", values, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameBetween(String value1, String value2) {
            addCriterion("BANK_BRANCH_NAME between", value1, value2, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameNotBetween(String value1, String value2) {
            addCriterion("BANK_BRANCH_NAME not between", value1, value2, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(String value) {
            addCriterion("BANK_NAME =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(String value) {
            addCriterion("BANK_NAME <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(String value) {
            addCriterion("BANK_NAME >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_NAME >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(String value) {
            addCriterion("BANK_NAME <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(String value) {
            addCriterion("BANK_NAME <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLike(String value) {
            addCriterion("BANK_NAME like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotLike(String value) {
            addCriterion("BANK_NAME not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<String> values) {
            addCriterion("BANK_NAME in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<String> values) {
            addCriterion("BANK_NAME not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(String value1, String value2) {
            addCriterion("BANK_NAME between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(String value1, String value2) {
            addCriterion("BANK_NAME not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeIsNull() {
            addCriterion("BRANCH_INTER_BANK_CODE is null");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeIsNotNull() {
            addCriterion("BRANCH_INTER_BANK_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeEqualTo(String value) {
            addCriterion("BRANCH_INTER_BANK_CODE =", value, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeNotEqualTo(String value) {
            addCriterion("BRANCH_INTER_BANK_CODE <>", value, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeGreaterThan(String value) {
            addCriterion("BRANCH_INTER_BANK_CODE >", value, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeGreaterThanOrEqualTo(String value) {
            addCriterion("BRANCH_INTER_BANK_CODE >=", value, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeLessThan(String value) {
            addCriterion("BRANCH_INTER_BANK_CODE <", value, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeLessThanOrEqualTo(String value) {
            addCriterion("BRANCH_INTER_BANK_CODE <=", value, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeLike(String value) {
            addCriterion("BRANCH_INTER_BANK_CODE like", value, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeNotLike(String value) {
            addCriterion("BRANCH_INTER_BANK_CODE not like", value, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeIn(List<String> values) {
            addCriterion("BRANCH_INTER_BANK_CODE in", values, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeNotIn(List<String> values) {
            addCriterion("BRANCH_INTER_BANK_CODE not in", values, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeBetween(String value1, String value2) {
            addCriterion("BRANCH_INTER_BANK_CODE between", value1, value2, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andBranchInterBankCodeNotBetween(String value1, String value2) {
            addCriterion("BRANCH_INTER_BANK_CODE not between", value1, value2, "branchInterBankCode");
            return (Criteria) this;
        }

        public Criteria andCertificateNoIsNull() {
            addCriterion("CERTIFICATE_NO is null");
            return (Criteria) this;
        }

        public Criteria andCertificateNoIsNotNull() {
            addCriterion("CERTIFICATE_NO is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateNoEqualTo(String value) {
            addCriterion("CERTIFICATE_NO =", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoNotEqualTo(String value) {
            addCriterion("CERTIFICATE_NO <>", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoGreaterThan(String value) {
            addCriterion("CERTIFICATE_NO >", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIFICATE_NO >=", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoLessThan(String value) {
            addCriterion("CERTIFICATE_NO <", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoLessThanOrEqualTo(String value) {
            addCriterion("CERTIFICATE_NO <=", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoLike(String value) {
            addCriterion("CERTIFICATE_NO like", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoNotLike(String value) {
            addCriterion("CERTIFICATE_NO not like", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoIn(List<String> values) {
            addCriterion("CERTIFICATE_NO in", values, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoNotIn(List<String> values) {
            addCriterion("CERTIFICATE_NO not in", values, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoBetween(String value1, String value2) {
            addCriterion("CERTIFICATE_NO between", value1, value2, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoNotBetween(String value1, String value2) {
            addCriterion("CERTIFICATE_NO not between", value1, value2, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIsNull() {
            addCriterion("CERTIFICATE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIsNotNull() {
            addCriterion("CERTIFICATE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeEqualTo(String value) {
            addCriterion("CERTIFICATE_TYPE =", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotEqualTo(String value) {
            addCriterion("CERTIFICATE_TYPE <>", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeGreaterThan(String value) {
            addCriterion("CERTIFICATE_TYPE >", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIFICATE_TYPE >=", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeLessThan(String value) {
            addCriterion("CERTIFICATE_TYPE <", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeLessThanOrEqualTo(String value) {
            addCriterion("CERTIFICATE_TYPE <=", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeLike(String value) {
            addCriterion("CERTIFICATE_TYPE like", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotLike(String value) {
            addCriterion("CERTIFICATE_TYPE not like", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIn(List<String> values) {
            addCriterion("CERTIFICATE_TYPE in", values, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotIn(List<String> values) {
            addCriterion("CERTIFICATE_TYPE not in", values, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeBetween(String value1, String value2) {
            addCriterion("CERTIFICATE_TYPE between", value1, value2, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotBetween(String value1, String value2) {
            addCriterion("CERTIFICATE_TYPE not between", value1, value2, "certificateType");
            return (Criteria) this;
        }

        public Criteria andChannelIdIsNull() {
            addCriterion("CHANNEL_ID is null");
            return (Criteria) this;
        }

        public Criteria andChannelIdIsNotNull() {
            addCriterion("CHANNEL_ID is not null");
            return (Criteria) this;
        }

        public Criteria andChannelIdEqualTo(String value) {
            addCriterion("CHANNEL_ID =", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotEqualTo(String value) {
            addCriterion("CHANNEL_ID <>", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThan(String value) {
            addCriterion("CHANNEL_ID >", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL_ID >=", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThan(String value) {
            addCriterion("CHANNEL_ID <", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL_ID <=", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLike(String value) {
            addCriterion("CHANNEL_ID like", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotLike(String value) {
            addCriterion("CHANNEL_ID not like", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdIn(List<String> values) {
            addCriterion("CHANNEL_ID in", values, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotIn(List<String> values) {
            addCriterion("CHANNEL_ID not in", values, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdBetween(String value1, String value2) {
            addCriterion("CHANNEL_ID between", value1, value2, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotBetween(String value1, String value2) {
            addCriterion("CHANNEL_ID not between", value1, value2, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelNameIsNull() {
            addCriterion("CHANNEL_NAME is null");
            return (Criteria) this;
        }

        public Criteria andChannelNameIsNotNull() {
            addCriterion("CHANNEL_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andChannelNameEqualTo(String value) {
            addCriterion("CHANNEL_NAME =", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameNotEqualTo(String value) {
            addCriterion("CHANNEL_NAME <>", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameGreaterThan(String value) {
            addCriterion("CHANNEL_NAME >", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL_NAME >=", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameLessThan(String value) {
            addCriterion("CHANNEL_NAME <", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL_NAME <=", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameLike(String value) {
            addCriterion("CHANNEL_NAME like", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameNotLike(String value) {
            addCriterion("CHANNEL_NAME not like", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameIn(List<String> values) {
            addCriterion("CHANNEL_NAME in", values, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameNotIn(List<String> values) {
            addCriterion("CHANNEL_NAME not in", values, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameBetween(String value1, String value2) {
            addCriterion("CHANNEL_NAME between", value1, value2, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameNotBetween(String value1, String value2) {
            addCriterion("CHANNEL_NAME not between", value1, value2, "channelName");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNull() {
            addCriterion("CONTRACT_NO is null");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNotNull() {
            addCriterion("CONTRACT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andContractNoEqualTo(String value) {
            addCriterion("CONTRACT_NO =", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotEqualTo(String value) {
            addCriterion("CONTRACT_NO <>", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThan(String value) {
            addCriterion("CONTRACT_NO >", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("CONTRACT_NO >=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThan(String value) {
            addCriterion("CONTRACT_NO <", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThanOrEqualTo(String value) {
            addCriterion("CONTRACT_NO <=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLike(String value) {
            addCriterion("CONTRACT_NO like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotLike(String value) {
            addCriterion("CONTRACT_NO not like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoIn(List<String> values) {
            addCriterion("CONTRACT_NO in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotIn(List<String> values) {
            addCriterion("CONTRACT_NO not in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoBetween(String value1, String value2) {
            addCriterion("CONTRACT_NO between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotBetween(String value1, String value2) {
            addCriterion("CONTRACT_NO not between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameIsNull() {
            addCriterion("DEPOSIT_ACCT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameIsNotNull() {
            addCriterion("DEPOSIT_ACCT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameEqualTo(String value) {
            addCriterion("DEPOSIT_ACCT_NAME =", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameNotEqualTo(String value) {
            addCriterion("DEPOSIT_ACCT_NAME <>", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameGreaterThan(String value) {
            addCriterion("DEPOSIT_ACCT_NAME >", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameGreaterThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_ACCT_NAME >=", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameLessThan(String value) {
            addCriterion("DEPOSIT_ACCT_NAME <", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameLessThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_ACCT_NAME <=", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameLike(String value) {
            addCriterion("DEPOSIT_ACCT_NAME like", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameNotLike(String value) {
            addCriterion("DEPOSIT_ACCT_NAME not like", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameIn(List<String> values) {
            addCriterion("DEPOSIT_ACCT_NAME in", values, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameNotIn(List<String> values) {
            addCriterion("DEPOSIT_ACCT_NAME not in", values, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameBetween(String value1, String value2) {
            addCriterion("DEPOSIT_ACCT_NAME between", value1, value2, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameNotBetween(String value1, String value2) {
            addCriterion("DEPOSIT_ACCT_NAME not between", value1, value2, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositNameIsNull() {
            addCriterion("DEPOSIT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDepositNameIsNotNull() {
            addCriterion("DEPOSIT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDepositNameEqualTo(String value) {
            addCriterion("DEPOSIT_NAME =", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameNotEqualTo(String value) {
            addCriterion("DEPOSIT_NAME <>", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameGreaterThan(String value) {
            addCriterion("DEPOSIT_NAME >", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameGreaterThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_NAME >=", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameLessThan(String value) {
            addCriterion("DEPOSIT_NAME <", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameLessThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_NAME <=", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameLike(String value) {
            addCriterion("DEPOSIT_NAME like", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameNotLike(String value) {
            addCriterion("DEPOSIT_NAME not like", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameIn(List<String> values) {
            addCriterion("DEPOSIT_NAME in", values, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameNotIn(List<String> values) {
            addCriterion("DEPOSIT_NAME not in", values, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameBetween(String value1, String value2) {
            addCriterion("DEPOSIT_NAME between", value1, value2, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameNotBetween(String value1, String value2) {
            addCriterion("DEPOSIT_NAME not between", value1, value2, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositCityIsNull() {
            addCriterion("DEPOSIT_CITY is null");
            return (Criteria) this;
        }

        public Criteria andDepositCityIsNotNull() {
            addCriterion("DEPOSIT_CITY is not null");
            return (Criteria) this;
        }

        public Criteria andDepositCityEqualTo(String value) {
            addCriterion("DEPOSIT_CITY =", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityNotEqualTo(String value) {
            addCriterion("DEPOSIT_CITY <>", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityGreaterThan(String value) {
            addCriterion("DEPOSIT_CITY >", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityGreaterThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_CITY >=", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityLessThan(String value) {
            addCriterion("DEPOSIT_CITY <", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityLessThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_CITY <=", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityLike(String value) {
            addCriterion("DEPOSIT_CITY like", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityNotLike(String value) {
            addCriterion("DEPOSIT_CITY not like", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityIn(List<String> values) {
            addCriterion("DEPOSIT_CITY in", values, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityNotIn(List<String> values) {
            addCriterion("DEPOSIT_CITY not in", values, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityBetween(String value1, String value2) {
            addCriterion("DEPOSIT_CITY between", value1, value2, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityNotBetween(String value1, String value2) {
            addCriterion("DEPOSIT_CITY not between", value1, value2, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositProvIsNull() {
            addCriterion("DEPOSIT_PROV is null");
            return (Criteria) this;
        }

        public Criteria andDepositProvIsNotNull() {
            addCriterion("DEPOSIT_PROV is not null");
            return (Criteria) this;
        }

        public Criteria andDepositProvEqualTo(String value) {
            addCriterion("DEPOSIT_PROV =", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvNotEqualTo(String value) {
            addCriterion("DEPOSIT_PROV <>", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvGreaterThan(String value) {
            addCriterion("DEPOSIT_PROV >", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvGreaterThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_PROV >=", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvLessThan(String value) {
            addCriterion("DEPOSIT_PROV <", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvLessThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_PROV <=", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvLike(String value) {
            addCriterion("DEPOSIT_PROV like", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvNotLike(String value) {
            addCriterion("DEPOSIT_PROV not like", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvIn(List<String> values) {
            addCriterion("DEPOSIT_PROV in", values, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvNotIn(List<String> values) {
            addCriterion("DEPOSIT_PROV not in", values, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvBetween(String value1, String value2) {
            addCriterion("DEPOSIT_PROV between", value1, value2, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvNotBetween(String value1, String value2) {
            addCriterion("DEPOSIT_PROV not between", value1, value2, "depositProv");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeIsNull() {
            addCriterion("INTER_BANK_CODE is null");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeIsNotNull() {
            addCriterion("INTER_BANK_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeEqualTo(String value) {
            addCriterion("INTER_BANK_CODE =", value, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeNotEqualTo(String value) {
            addCriterion("INTER_BANK_CODE <>", value, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeGreaterThan(String value) {
            addCriterion("INTER_BANK_CODE >", value, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeGreaterThanOrEqualTo(String value) {
            addCriterion("INTER_BANK_CODE >=", value, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeLessThan(String value) {
            addCriterion("INTER_BANK_CODE <", value, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeLessThanOrEqualTo(String value) {
            addCriterion("INTER_BANK_CODE <=", value, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeLike(String value) {
            addCriterion("INTER_BANK_CODE like", value, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeNotLike(String value) {
            addCriterion("INTER_BANK_CODE not like", value, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeIn(List<String> values) {
            addCriterion("INTER_BANK_CODE in", values, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeNotIn(List<String> values) {
            addCriterion("INTER_BANK_CODE not in", values, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeBetween(String value1, String value2) {
            addCriterion("INTER_BANK_CODE between", value1, value2, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andInterBankCodeNotBetween(String value1, String value2) {
            addCriterion("INTER_BANK_CODE not between", value1, value2, "interBankCode");
            return (Criteria) this;
        }

        public Criteria andOperOrgIsNull() {
            addCriterion("OPER_ORG is null");
            return (Criteria) this;
        }

        public Criteria andOperOrgIsNotNull() {
            addCriterion("OPER_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andOperOrgEqualTo(String value) {
            addCriterion("OPER_ORG =", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgNotEqualTo(String value) {
            addCriterion("OPER_ORG <>", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgGreaterThan(String value) {
            addCriterion("OPER_ORG >", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgGreaterThanOrEqualTo(String value) {
            addCriterion("OPER_ORG >=", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgLessThan(String value) {
            addCriterion("OPER_ORG <", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgLessThanOrEqualTo(String value) {
            addCriterion("OPER_ORG <=", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgLike(String value) {
            addCriterion("OPER_ORG like", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgNotLike(String value) {
            addCriterion("OPER_ORG not like", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgIn(List<String> values) {
            addCriterion("OPER_ORG in", values, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgNotIn(List<String> values) {
            addCriterion("OPER_ORG not in", values, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgBetween(String value1, String value2) {
            addCriterion("OPER_ORG between", value1, value2, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgNotBetween(String value1, String value2) {
            addCriterion("OPER_ORG not between", value1, value2, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameIsNull() {
            addCriterion("OTHER_BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameIsNotNull() {
            addCriterion("OTHER_BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameEqualTo(String value) {
            addCriterion("OTHER_BANK_NAME =", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameNotEqualTo(String value) {
            addCriterion("OTHER_BANK_NAME <>", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameGreaterThan(String value) {
            addCriterion("OTHER_BANK_NAME >", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("OTHER_BANK_NAME >=", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameLessThan(String value) {
            addCriterion("OTHER_BANK_NAME <", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameLessThanOrEqualTo(String value) {
            addCriterion("OTHER_BANK_NAME <=", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameLike(String value) {
            addCriterion("OTHER_BANK_NAME like", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameNotLike(String value) {
            addCriterion("OTHER_BANK_NAME not like", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameIn(List<String> values) {
            addCriterion("OTHER_BANK_NAME in", values, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameNotIn(List<String> values) {
            addCriterion("OTHER_BANK_NAME not in", values, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameBetween(String value1, String value2) {
            addCriterion("OTHER_BANK_NAME between", value1, value2, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameNotBetween(String value1, String value2) {
            addCriterion("OTHER_BANK_NAME not between", value1, value2, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andTransPasswordIsNull() {
            addCriterion("TRANS_PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andTransPasswordIsNotNull() {
            addCriterion("TRANS_PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andTransPasswordEqualTo(String value) {
            addCriterion("TRANS_PASSWORD =", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordNotEqualTo(String value) {
            addCriterion("TRANS_PASSWORD <>", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordGreaterThan(String value) {
            addCriterion("TRANS_PASSWORD >", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("TRANS_PASSWORD >=", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordLessThan(String value) {
            addCriterion("TRANS_PASSWORD <", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordLessThanOrEqualTo(String value) {
            addCriterion("TRANS_PASSWORD <=", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordLike(String value) {
            addCriterion("TRANS_PASSWORD like", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordNotLike(String value) {
            addCriterion("TRANS_PASSWORD not like", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordIn(List<String> values) {
            addCriterion("TRANS_PASSWORD in", values, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordNotIn(List<String> values) {
            addCriterion("TRANS_PASSWORD not in", values, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordBetween(String value1, String value2) {
            addCriterion("TRANS_PASSWORD between", value1, value2, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordNotBetween(String value1, String value2) {
            addCriterion("TRANS_PASSWORD not between", value1, value2, "transPassword");
            return (Criteria) this;
        }

        public Criteria andAdsourceIsNull() {
            addCriterion("ADSOURCE is null");
            return (Criteria) this;
        }

        public Criteria andAdsourceIsNotNull() {
            addCriterion("ADSOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andAdsourceEqualTo(String value) {
            addCriterion("ADSOURCE =", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceNotEqualTo(String value) {
            addCriterion("ADSOURCE <>", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceGreaterThan(String value) {
            addCriterion("ADSOURCE >", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceGreaterThanOrEqualTo(String value) {
            addCriterion("ADSOURCE >=", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceLessThan(String value) {
            addCriterion("ADSOURCE <", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceLessThanOrEqualTo(String value) {
            addCriterion("ADSOURCE <=", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceLike(String value) {
            addCriterion("ADSOURCE like", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceNotLike(String value) {
            addCriterion("ADSOURCE not like", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceIn(List<String> values) {
            addCriterion("ADSOURCE in", values, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceNotIn(List<String> values) {
            addCriterion("ADSOURCE not in", values, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceBetween(String value1, String value2) {
            addCriterion("ADSOURCE between", value1, value2, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceNotBetween(String value1, String value2) {
            addCriterion("ADSOURCE not between", value1, value2, "adsource");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodIsNull() {
            addCriterion("ACCEPT_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodIsNotNull() {
            addCriterion("ACCEPT_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodEqualTo(String value) {
            addCriterion("ACCEPT_METHOD =", value, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodNotEqualTo(String value) {
            addCriterion("ACCEPT_METHOD <>", value, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodGreaterThan(String value) {
            addCriterion("ACCEPT_METHOD >", value, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodGreaterThanOrEqualTo(String value) {
            addCriterion("ACCEPT_METHOD >=", value, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodLessThan(String value) {
            addCriterion("ACCEPT_METHOD <", value, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodLessThanOrEqualTo(String value) {
            addCriterion("ACCEPT_METHOD <=", value, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodLike(String value) {
            addCriterion("ACCEPT_METHOD like", value, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodNotLike(String value) {
            addCriterion("ACCEPT_METHOD not like", value, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodIn(List<String> values) {
            addCriterion("ACCEPT_METHOD in", values, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodNotIn(List<String> values) {
            addCriterion("ACCEPT_METHOD not in", values, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodBetween(String value1, String value2) {
            addCriterion("ACCEPT_METHOD between", value1, value2, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAcceptMethodNotBetween(String value1, String value2) {
            addCriterion("ACCEPT_METHOD not between", value1, value2, "acceptMethod");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExIsNull() {
            addCriterion("APP_SHEET_SERIALNO_EX is null");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExIsNotNull() {
            addCriterion("APP_SHEET_SERIALNO_EX is not null");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExEqualTo(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX =", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExNotEqualTo(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX <>", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExGreaterThan(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX >", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExGreaterThanOrEqualTo(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX >=", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExLessThan(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX <", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExLessThanOrEqualTo(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX <=", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExLike(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX like", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExNotLike(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX not like", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExIn(List<String> values) {
            addCriterion("APP_SHEET_SERIALNO_EX in", values, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExNotIn(List<String> values) {
            addCriterion("APP_SHEET_SERIALNO_EX not in", values, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExBetween(String value1, String value2) {
            addCriterion("APP_SHEET_SERIALNO_EX between", value1, value2, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExNotBetween(String value1, String value2) {
            addCriterion("APP_SHEET_SERIALNO_EX not between", value1, value2, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andCreatedTsIsNull() {
            addCriterion("CREATED_TS is null");
            return (Criteria) this;
        }

        public Criteria andCreatedTsIsNotNull() {
            addCriterion("CREATED_TS is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedTsEqualTo(Date value) {
            addCriterion("CREATED_TS =", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsNotEqualTo(Date value) {
            addCriterion("CREATED_TS <>", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsGreaterThan(Date value) {
            addCriterion("CREATED_TS >", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATED_TS >=", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsLessThan(Date value) {
            addCriterion("CREATED_TS <", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsLessThanOrEqualTo(Date value) {
            addCriterion("CREATED_TS <=", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsIn(List<Date> values) {
            addCriterion("CREATED_TS in", values, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsNotIn(List<Date> values) {
            addCriterion("CREATED_TS not in", values, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsBetween(Date value1, Date value2) {
            addCriterion("CREATED_TS between", value1, value2, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsNotBetween(Date value1, Date value2) {
            addCriterion("CREATED_TS not between", value1, value2, "createdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsIsNull() {
            addCriterion("LAST_UPD_TS is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsIsNotNull() {
            addCriterion("LAST_UPD_TS is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsEqualTo(Date value) {
            addCriterion("LAST_UPD_TS =", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsNotEqualTo(Date value) {
            addCriterion("LAST_UPD_TS <>", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsGreaterThan(Date value) {
            addCriterion("LAST_UPD_TS >", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsGreaterThanOrEqualTo(Date value) {
            addCriterion("LAST_UPD_TS >=", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsLessThan(Date value) {
            addCriterion("LAST_UPD_TS <", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsLessThanOrEqualTo(Date value) {
            addCriterion("LAST_UPD_TS <=", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsIn(List<Date> values) {
            addCriterion("LAST_UPD_TS in", values, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsNotIn(List<Date> values) {
            addCriterion("LAST_UPD_TS not in", values, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsBetween(Date value1, Date value2) {
            addCriterion("LAST_UPD_TS between", value1, value2, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsNotBetween(Date value1, Date value2) {
            addCriterion("LAST_UPD_TS not between", value1, value2, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonIsNull() {
            addCriterion("FAILTURE_REASON is null");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonIsNotNull() {
            addCriterion("FAILTURE_REASON is not null");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonEqualTo(String value) {
            addCriterion("FAILTURE_REASON =", value, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonNotEqualTo(String value) {
            addCriterion("FAILTURE_REASON <>", value, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonGreaterThan(String value) {
            addCriterion("FAILTURE_REASON >", value, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonGreaterThanOrEqualTo(String value) {
            addCriterion("FAILTURE_REASON >=", value, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonLessThan(String value) {
            addCriterion("FAILTURE_REASON <", value, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonLessThanOrEqualTo(String value) {
            addCriterion("FAILTURE_REASON <=", value, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonLike(String value) {
            addCriterion("FAILTURE_REASON like", value, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonNotLike(String value) {
            addCriterion("FAILTURE_REASON not like", value, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonIn(List<String> values) {
            addCriterion("FAILTURE_REASON in", values, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonNotIn(List<String> values) {
            addCriterion("FAILTURE_REASON not in", values, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonBetween(String value1, String value2) {
            addCriterion("FAILTURE_REASON between", value1, value2, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andFailtureReasonNotBetween(String value1, String value2) {
            addCriterion("FAILTURE_REASON not between", value1, value2, "failtureReason");
            return (Criteria) this;
        }

        public Criteria andBankCodeIsNull() {
            addCriterion("BANK_CODE is null");
            return (Criteria) this;
        }

        public Criteria andBankCodeIsNotNull() {
            addCriterion("BANK_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andBankCodeEqualTo(String value) {
            addCriterion("BANK_CODE =", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotEqualTo(String value) {
            addCriterion("BANK_CODE <>", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeGreaterThan(String value) {
            addCriterion("BANK_CODE >", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_CODE >=", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLessThan(String value) {
            addCriterion("BANK_CODE <", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLessThanOrEqualTo(String value) {
            addCriterion("BANK_CODE <=", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLike(String value) {
            addCriterion("BANK_CODE like", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotLike(String value) {
            addCriterion("BANK_CODE not like", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeIn(List<String> values) {
            addCriterion("BANK_CODE in", values, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotIn(List<String> values) {
            addCriterion("BANK_CODE not in", values, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeBetween(String value1, String value2) {
            addCriterion("BANK_CODE between", value1, value2, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotBetween(String value1, String value2) {
            addCriterion("BANK_CODE not between", value1, value2, "bankCode");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoIsNull() {
            addCriterion("AGREEMENT_SIGN_NO is null");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoIsNotNull() {
            addCriterion("AGREEMENT_SIGN_NO is not null");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoEqualTo(String value) {
            addCriterion("AGREEMENT_SIGN_NO =", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoNotEqualTo(String value) {
            addCriterion("AGREEMENT_SIGN_NO <>", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoGreaterThan(String value) {
            addCriterion("AGREEMENT_SIGN_NO >", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoGreaterThanOrEqualTo(String value) {
            addCriterion("AGREEMENT_SIGN_NO >=", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoLessThan(String value) {
            addCriterion("AGREEMENT_SIGN_NO <", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoLessThanOrEqualTo(String value) {
            addCriterion("AGREEMENT_SIGN_NO <=", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoLike(String value) {
            addCriterion("AGREEMENT_SIGN_NO like", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoNotLike(String value) {
            addCriterion("AGREEMENT_SIGN_NO not like", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoIn(List<String> values) {
            addCriterion("AGREEMENT_SIGN_NO in", values, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoNotIn(List<String> values) {
            addCriterion("AGREEMENT_SIGN_NO not in", values, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoBetween(String value1, String value2) {
            addCriterion("AGREEMENT_SIGN_NO between", value1, value2, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoNotBetween(String value1, String value2) {
            addCriterion("AGREEMENT_SIGN_NO not between", value1, value2, "agreementSignNo");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}